Libris Britannia 4

home *** CD-ROM | disk | FTP | other *** search

/ Libris Britannia 4 / science library(b).zip / science library(b) / PROGRAMM / DB_CLIPP / 1989.ZIP / README < prev

Wrap

Text File | 1990-05-19 | 45KB | 918 lines

For immediate release May 19, 1990 --------------------- - QQuery Version 2.10D - QQuery for FoxPro! Elaborate query management system for FoxBASE+ and now for FoxPro! Helps user create, store, and replay queries to use with your reports and/or processes. Includes context sensitive on- line help system. Registered users ($10) receive source code and unlimited runtime rights. Version 2.10D adds modifiable related file field names pop up menus in both the FoxBASE+ and FoxPro versions. QQuery for FoxPro is comparable in appearance, navigation, and function with QQuery for FoxBASE+ while taking advantage of FoxPro's 25 work areas and 254 field data files. New features in version 2.10D: 1. Pop up menus are available at the touch of the left and right arrow keys for the field names and sample data of ANY OR ALL OTHER OPEN WORK AREAS. 2. User definable exclusion of Help, Error and any other files you specify from the field names pop up menus. 3. For greater control over the contents of field names pop up menus, a new utility program is supplied, QQDMEDIT.PRG, a program for modifying any existing QQuery QDM memory file. 4. The left and right arrow keys now are used to either exit pop up menus with the highlighted choice OR to scan parallel pop up menus. 5. The same source code provided when you register may be used to compile QQuery to run under either FoxBASE+ or FoxPro versions 1.01 or later. Carlos Berguido 1722 Capella Court Petaluma, CA 94954 (707) 762-9067 For immediate release March 23, 1990 --------------------- - QQuery Version 2.10C - By popular demand, the following policies are established for QQuery, the logical expression builder and query manager for IBM FoxBASE+. QQuery is a 3rd party shareware product available for downloading in the library of the Fox Software forum on Compuserve, GO FOXFORUM. 1. UNLIMITED RUNTIME. A single registration fee licenses you to include the QQuery modules in any application you develop and to distribute any number of copies of these applications with no royalties whatsoever. 2. The registration fee has been reduced to $10 effective immediately. You will receive one 5 1/4" diskette (360k format) containing the QQuery program for FoxBASE+, a README file, and source code. 3. SOURCE CODE optimized for FoxBASE+ supplied on disk when you register. As a registered user, you are licensed to: a. Modify the code as desired to optimize QQuery for your applications. b. Modify and re-compile all or part of QQuery as desired to optimize QQuery to run under FoxPro and/or other platforms. c. Provide QQuery source code to your clients that require source code, as long as you provide a notice that use of QQuery other than from within your application requires registration. 4. Unconditional 30 day money back guarantee. Release 2.10C does not change or add any QQuery features. The purpose of this release is to incorporate the new policies in the source code and screen notices only. Carlos Berguido 1722 Capella Court Petaluma, CA 94954 (707) 762-9067 05/19/90 Q Q U E R Y (tm) Page i (c) 1989,1990 by Carlos Berguido - Vers 2.10D INFORMATION - TABLE OF CONTENTS - QUERY MANAGEMENT FOR FoxBASE+ and FoxPro . . . . . . . . . . 1 REGISTRATION NOTICE . . . . . . . . . . . . . . . . . . . . 1 FEATURES AND BENEFITS . . . . . . . . . . . . . . . . . . . 2 CAUTION: MULTI-USER . . . . . . . . . . . . . . . . . . . . 4 ONE OPEN DATA FILE WORK AREA NEEDED . . . . . . . . . . . . 4 QQUERY FILE DESCRIPTIONS . . . . . . . . . . . . . . . . . . 4 HOW QQUERY CREATES AND USES FILES . . . . . . . . . . . . . 5 QDB & QDX FILES: QUERY DATA FILES AND INDEXES . . . . . 5 QDM FILES: FIELD NAME POP UP MENUS . . . . . . . . . . 6 MULTIPLE WORK AREA FIELD NAME POP UP MENUS . . . . . . 6 EXCLUDING FILES FROM FIELD NAMES POP UP MENUS . . . . . 7 CUSTOM FIELD NAMES POP UP MENUS . . . . . . . . . . . . . . 8 MEMORY REQUIREMENTS . . . . . . . . . . . . . . . . . . . . 9 QQUERY MEMORY VARIABLES . . . . . . . . . . . . . . . . . . 10 CHANGING SCREEN COLORS . . . . . . . . . . . . . . . . . . . 11 PROCEDURE FILES . . . . . . . . . . . . . . . . . . . . . . 13 READ ONLY ACCESS . . . . . . . . . . . . . . . . . . . . . . 14 NOTICE REGARDING QQUERY SOURCE CODE . . . . . . . . . . . . 15 INSTALLATION . . . . . . . . . . . . . . . . . . . . . . . . 16 05/19/90 Q Q U E R Y (tm) Page 1 (c) 1989,1990 by Carlos Berguido - Vers 2.10D INFORMATION QUERY MANAGEMENT FOR FoxBASE+ and FoxPro QQuery was developed using the database language and extensions known as FoxBASE+ and FoxPro from FOX SOFTWARE, INC. of Perrysburg, Ohio. QQuery was created by a 3rd party, independent developer who is not affiliated with FOX SOFTWARE, INC. FOX SOFTWARE, INC. is not responsible for products that are developed using their language products. If you need help or information regarding QQuery, please direct your inquiry to the author and copyright holder of QQuery whose name appears below. REGISTRATION NOTICE QQuery is not public domain or free software. If you continue using QQuery after a 30 day trial period, you must register for a license to use QQuery. A single registration gives you royalty free unlimited runtime rights for applications you develop that use QQuery. To register, send $10 (Ten dollars U.S.) directly to the author: (30 day unconditional money back guarantee) Carlos Berguido Telephone: 1722 Capella Court (707) 762-9067 Petaluma, CA 94954 Please include your name, address, and QQuery version number. You will receive the latest version of QQuery INCLUDING ALL SOURCE CODE on a 5 1/4 inch diskette. The source code is designed to make navigating QQuery as comparable as possible whether it is run under FoxPro or FoxBASE+ except that the Enter key may also be used to exit the query Browse when running under FoxPro only. If you have not installed QQuery, please read the last page of this document regarding QQuery installation. The context sensitive Help system in the QQuery program is intended to provide step by step instruction in the operation of QQuery. In addition, you are urged to experiment and seek other sources of information in the science and art of creating and combining logical expressions. FoxBASE+ and FoxPro are registered trademarks of FOX SOFTWARE, INC. 05/19/90 Q Q U E R Y (tm) Page 2 (c) 1989,1990 by Carlos Berguido - Vers 2.10D INFORMATION - FEATURES AND BENEFITS - The information contained in this document is provided for system developers and anyone interested in some of the technical ins and outs of QQuery. FEATURE BENEFIT Stores queries in - Allows quick access to repeatedly used a database. queries. - Allows query creation and auditing by one group and use by others. Each query has a - Systemizes report headings. name and a - Makes it easy to locate and reuse queries. description of up to 55 characters. More than just SET - QQuery will SET FILTER up to the 160 FILTER. character limit on filter expressions. After exiting, the user can simply issue commands and only those records that meet the query condition will be included. - Also, at any time after exit with a query, the user has access to memory variables for the query name, description, and the up to 240 character condition itself for use in a FOR phrase in commands such as COPY, INDEX, LIST, and REPORT. - Program developers can call the QQuery procedure from inside their procedure files and take appropriate action in their programs depending on what is returned is the memory variables on QQuery's return. QQuery editor - Allows flexibility in the way queries such allows multiple as "Guests who stay for 10 days or more" field names and/or are stated: functions on both DATEOUT-DATEIN is after or matches 10 sides of each as well as: equation. DATEOUT is after or matches DATEIN+10 QQuery editor uses - User can see what options are available for pop-up menus. field names, functions, operators, nesting parenthesis, and connectors. - Saves hundreds of keystrokes, saves time, avoids misspellings. 05/19/90 Q Q U E R Y (tm) Page 3 (c) 1989,1990 by Carlos Berguido - Vers 2.10D INFORMATION FEATURE BENEFIT Contains many of - User can easily make a query insensitive to the most popular UPPER/lower case by choosing UPPER from a functions on pop pop-up menu: UPPER(CITY)='PERRYSBURG" up menus. - Make a query that ignores the last four digits of a 9 digit zip code and enter multiple random zips in one or more condition lines: LEFT(ZIP,5) is contained in "85718,85740" Field names pop up - Makes it easy to locate the correct field has sample data name because the user can see a sample of from user the data. Starting with version 2.10D, a database. field names pop up menu is available at the touch of a key for every open work area. Self contained - QQuery allows creating, listing, using, system. editing, renaming, deleting, and packing queries, all from familiar Lotus 1-2-3 style menus. Lotus and 1-2-3 are registered trademarks of Lotus Development Corporation. Context sensitive - The user does not have to know about proper auto-conversion of syntax. For example, if QQuery is user expressions expecting the user to enter a date to correct syntax. expression and the user just enters 1/1/89, it will automatically be converted to CTOD("1/1/89"), the correct syntax. - QQuery searches the environment for field names and variables to test each constant/expression. If the expression tests ok, QQuery will accept it as entered. If the expression doesn't make sense, QQuery will either put it in quotes, or convert it with VAL or CTOD, depending on whether a character, numeric, or date expression is expected. Permits queries - Point to field names of files in other work into other work areas in pop up menus whenever these fields areas to related in a related file are important to the files. query. For example, to find all the "Orders of $10,000 or more to Ohio customers": AMOUNT is after or matches 10000 .AND. customer->STATE matches "OH" 05/19/90 Q Q U E R Y (tm) Page 4 (c) 1989,1990 by Carlos Berguido - Vers 2.10D INFORMATION - CAUTION: MULTI-USER - QQuery has never been tested in a multi-user environment. There are no LOAD, CALL, or RUN commands in QQuery to worry about. Nonetheless, no attempt was made to manage collisions that might occur in a multi-user setting. If you would like to see a multi- user version of QQuery developed, please contact the author. In the meantime, please treat QQuery as you would any program that has only been tested in a single user environment. - ONE OPEN DATA FILE WORK AREA NEEDED - QQuery needs only one open work area and will find ANY unused work area to USE for files it manages. If all work areas are in USE when the program is called, QQuery will advise you that such is the case and return without executing. - QQUERY FILE DESCRIPTIONS - The following file is needed to run QQuery: FILENAME STRUCTURE CONTENTS ---------- --------- ------------------------------------------ QQUERY.FOX FOX FoxBASE+ 2.10 compiled procedure file - OR - QQUERY.FXP FXP FoxPro 1.02 compiled procedure file The following files are created by QQuery if they are not present in the environment: FILENAME STRUCTURE CONTENTS ---------- --------- ------------------------------------------ QQUERY.QST DBF Empty database structure used to make new alias.QDB's QQUERY.QSM MEM Memory variables for screen colors and feature options alias.QDB DBF Database of queries for user data file named <alias> alias.QDX IDX Index for above, key field is QDNAME alias.QDM MEM An image of the alias structures of all open files with sample data ?????? DBF Occasionally a FOX generated unique filename is used and subsequently erased, function SYS(3). The 3 alias files are not actually named "alias". "alias" is used above to indicate that the left hand portion of the filename is derived from the alias of your data file that has been USEd in the current work area. 05/19/90 Q Q U E R Y (tm) Page 5 (c) 1989,1990 by Carlos Berguido - Vers 2.10D INFORMATION - QQUERY FILES (continued) - The extension names QST, QSM, QDB, QDX, and QDM were chosen so that QQuery would not conflict with your existing file names and so you could identify the function of each QQuery file by name. - HOW QQUERY CREATES AND USES FILES - Each time QQuery is started, it looks to see if a data file is in USE in the currently selected work area. If not, it presents a directory of DBF files in the current directory and prompts you to enter the name of one. If none is entered, QQuery returns without executing further. Once QQuery is given a file in the current work area, it checks the current directory for a filename consisting of the alias as the left hand part of the file name and QDB as the right hand filename extension. For example, if ORDERS is the alias of the data file in the current directory, QQuery will search for a file named ORDERS.QDB. If QQuery can't find the QDB file, it will create one by copying the structure of the file QQUERY.QST to ORDERS.QDB. (If QQUERY.QST is not found in the current directory or path, QQuery will create a new QQUERY.QST in the current directory.) The single ORDERS.QDB file can store hundreds of queries to ORDERS and to any related files in unselected open work areas. - QDB & QDX FILES: QUERY DATA FILES AND INDEXES - In this example where ORDERS is the current work area alias, QQuery requires two other files. ORDERS.QDX is the index file for ORDERS.QDB. If the index file is not present, QQuery will create one. alias.QDB Fields: ----------------- QDNAME C 8 The query name (and index key) QDESCRIPT C 55 The plain language description of the query (use for report headings) QDLEDIT D 8 The last date edited (from the system date) QDCODE C 254 The coded condition used by the query editor QDQUERY C 240 The database language condition translated from the code 05/19/90 Q Q U E R Y (tm) Page 6 (c) 1989,1990 by Carlos Berguido - Vers 2.10D INFORMATION - QDM FILES: FIELD NAME POP UP MENUS - The third file in this example is ORDERS.QDM. This memory file is used for the pop up menus of field names and sample data from the ORDERS data file. Starting with version 2.10D of QQuery, field names and sample data from every other work area that was in use when the QDM file was created are also stored in this file. QDM files are always automatically created whenever there is no QDM in the current directory or in a PATH that has the same name as the alias of the data file currently selected. For example, if you have a data file alias ORDERS in use in the current work area and are starting QQuery for the first time with ORDERS, QQuery will create a memory file named ORDERS.QDM containing a list of all the field specifications of ORDERS (except memo fields) together with a portion of the data that is in the current ORDERS record when you start QQuery.) NOTE: To save disk space, when you have a group of several files open in various work areas, make sure you select the master file for that group every time before starting QQuery. That way, only one QDM file will ever be used for that group of files. - MULTIPLE WORK AREA FIELD NAME POP UP MENUS - Starting with version 2.10D of QQuery, whenever you see the field names pop up menu for the main file, you can also see additional field name pop ups for all other work areas that were open when the QDM file was created by using the left and right arrow keys. This feature of multiple work area field name pop up menus is enabled in QQuery by having "/FLDPOP" in the QQSCOPTION variable in the QQUERY.QSM system file. This is the default when you install version 2.10D. The only reason not to enable this feature is if you run out of memory and you don't want to increase MVARSIZ in the CONFIG.FX or CONFIG.FP file. The extra pop-up lists require on average 45 bytes per field name. QDM files created by earlier versions of QQuery are completely compatible with version 2.10D. In fact, if you use your existing QQUERY.QSM file that has QQSCOPTION="" with version 2.10D, QQuery will generate a field name pop up for the main file only, just as it did in earlier versions. If you wish to add the other work area pop up menus to an application that already has one or more QDM files, first install version 2.10D of QQuery. Delete the existing QDM file. Open up all the related files in all the work areas you need and open the main file. Start QQuery. A new <alias>.QDM with all the work area field names and sample data will be created automatically. 05/19/90 Q Q U E R Y (tm) Page 7 (c) 1989,1990 by Carlos Berguido - Vers 2.10D INFORMATION QQSCOPTION is a variable in the QQuery system memory file QQUERY.QSM. To enable field pop up menus for all open work areas, have the QQSCOPTION variable include the string "/FLDPOP" (quotes not needed). That is the default when you install version 2.10D. To modify any existing QQUERY.QSM file: RESTORE FROM QQUERY.QSM QQSCOPTION="/FLDPOP" SAVE TO QQUERY.QSM To save memory, if you do NOT want QQuery to create multiple work area pop ups QDM files, substitute QQSCOPTION="" - EXCLUDING FILES FROM FIELD NAMES POP UP MENUS - You may not want to see field name pop ups for ALL the open work areas, such as HELP and ERROR files. QQSCOPTION can contain a list of file aliases to exclude from the fields pop up menus. For example, to include all files from all work areas EXCEPT a help file and an error file, assuming the alias of each is HELP and ERROR respectively, simply list the alias names separated by commas after the /FLDPOP string in the QQSCOPTION variable: QQSCOPTION="/FLDPOP:HELP,ERROR*" Don't forget the colon (:) after /FLDPOP and the asterisk (*) after the last file name. If you leave out the colon and the asterisk, any listed files will NOT be excluded. If you want to change the Samples or if you change the Structure of this data file, erase the file that begins with your data file name and ends with the extension .QDM. Then, the next time you start QQuery, have your data files positioned at records that you want to use for the pop up sample data. Start QQuery and it will create new field names pop up menus. You may also use QQDMEDIT described on the next page to modify existing QDM files. If you change field names or delete fields altogether, you will have to adjust any query condition that uses the old field name. Each time you select a query from the LIST function, QQuery makes a quick check to see if that all field names and variables in the condition can still be found in the environment. If not, you will be offered the choice of editing the query to correct it or going back to the top menu. QQuery will not permit you to USE a query that contains invalid statements. 05/19/90 Q Q U E R Y (tm) Page 8 (c) 1989,1990 by Carlos Berguido - Vers 2.10D INFORMATION - CUSTOM FIELD NAMES POP UP MENUS - QQDMEDIT.PRG is a free utility program provided that lets you customize existing field names pop up menus (QDM files): * Modify the default field names pop up menu title. * Change the content of any field name line. Some users are replacing sample data with field descriptions. * Add new lines. * Delete existing lines. * Add new children files and fields. Print the QQDMEDIT.PRG file for details, the following is an overview. Anytime after QQuery creates a QDM file, you make change it by entering: DO QQDMEDIT at either the FoxBASE+ dot prompt or in the FoxPro command window. You will see a list of any existing QDM files in the current directory. Enter the name of the QDM file you want to modify. The QDM file will be automatically converted to a text file and presented to you for full screen editing using the built in FoxBASE+ or FoxPro editor. After making changes, save the changes with the Ctrl-W key or abandon any changes with the Escape key. The field names information will be automatically converted back to QDM format, ready to use with QQuery. 05/19/90 Q Q U E R Y (tm) Page 9 (c) 1989,1990 by Carlos Berguido - Vers 2.10D INFORMATION - MEMORY REQUIREMENTS - Use the information in this section only if you are getting the Fox error message number 21: "String memory variable area overflow" when you run QQuery with your biggest combination of data files. QQuery uses lots of memory variable space for pop up menus. As a result, you may run out of room in memory when running QQuery with the Fox default memory variable size of 6,000 bytes. QQuery and Fox could start to run out of memory if you have many field name pop up menus with many fields, all available at once. Each menu item varies in memory requirement depending on the field type and contents. In practice, I have measured an average of 45 bytes per field name pop up item. To allow a margin for error, use 50 bytes per menu item. Fox uses an item named MVARSIZ in a CONFIG file to permit you to increase the amount of memory allocted to variables. (CONFIG.FX for FoxBASE+, CONFIG.FP for Foxpro). If you get the "String memory variable area overflow" error message, try increasing MVARSIZ in the CONFIG file by 50 bytes for each field over 25 plus whatever you need in any program that calls QQuery. For example, if your related data files have between them 145 fields, increase memory by (145-25)*50=6000 bytes. If you need to change the memory allocation, see the INSTALLATION section at the end of this document about changing the CONFIG file. You will want to be sure it contains: MVARSIZ=n where n is any number greater than the Fox default of 6. Each increment represents 1,000 bytes, so MVARSIZ=12 would give you 12,000 bytes for memory variables. 05/19/90 Q Q U E R Y (tm) Page 10 (c) 1989,1990 by Carlos Berguido - Vers 2.10D INFORMATION - QQUERY MEMORY VARIABLES - QQuery does NOT require the use of PARAMETERS. This was done so that QQuery would be easy to use from the dot prompt. The following memory variables are PUBLIC on return from QQuery: QQNAME C The query nickname, trimmed QQDESC C The user description, trimmed QQUERY C up to 240 characters for the condition used by calling program for subsequent SET FILTER TO, FOR, or WHILE phrases, trimmed These strings will return as nuls if the user QUITs so that any program you DO QQuery from can take appropriate action. If you are a developer with a few lines of code you can spare, you might try these lines in your programs after DO QQUERY To combine the name and description for reports: QQDESC=QQNAME+' - '+QQDESC To test for especially long conditions: IF LEN(QQUERY)>210 && between 210 and 240, BIG COPY TO T FOR &QQUERY USE T ALIAS <your data file name> ENDIF ... do report expecting an ALIAS of <your data file name> USE DELETE FILE T.DBF If the condition is 240 characters, the COPY TO T FOR &QQUERY command will expand to the maximum 254 characters allowed in a FoxBASE+ command line. (NOTE: FoxPro increases the limit to 1024 characters per command line) SET FILTER TO has a limit of 160 characters. That doesn't mean that queries need be limited to that length. A command that combines sorting and filtering in one step is: INDEX ON <your sorting expression> TO <filename> FOR &QQUERY Make sure you test the LENgth of the QQUERY memory variable before issuing commands in your programs. Remember the limit of 254 characters in any command line means AFTER macro expansion. If the condition is too big for one method, you can always resort to copying to a temporary file as in the above IF ENDIF example. Be flexible! 05/19/90 Q Q U E R Y (tm) Page 11 (c) 1989,1990 by Carlos Berguido - Vers 2.10D INFORMATION - CHANGING SCREEN COLORS - There is a wide range of color monitors out in the world, and what is bright yellow on one monitor is dark brown on another. This section is about changing screen colors from the default values of QQuery to something more to your liking. QQuery will create a memory file QQUERY.QSM if it is not present in the environment with the following default values for screen colors. QQUERY.QSM DEFAULT SCREEN COLORS MEMORY VARIABLES: Mono normal . QQSCRNNRML="W/N,N/W,N" editor fields . QQSCRNBOLD="W+/N" blinking messages . QQSCRNBLNK="W+*/N,X" help border . QQSCRNHLPB="N/W" help text . QQSCRNHLPT="W/B,N/W" Color normal . QQSCOLNRML="W/B,W/R,B" editor fields . QQSCOLBOLD="W+/B" blinking messages . QQSCOLBLNK="W*/B,B/B" help border . QQSCOLHLPB="N/W" help text . QQSCOLHLPT="N/G,N/W" Options . QQSCOPTION="/FLDPOP" Whenever QQuery is started with this file present, QQuery will use the values for screen colors that are in the file. This means you can substitute different values for screen colors and QQuery will use them. See the FIELD NAMES POP UP MENUS section of this documentation for info about the QQSCOPTION variable. On a color monitor, the default color for normal display in QQuery is determined by the variable QQSCOLNRML, which by default is: " W/B , W/R , B " Normal text: white on blue, Enhanced: white on red, Border: blue The abbreviations for all the colors are listed under the SET COLOR TO command in your database manual of Commands and Functions. You can get ideas for potential color combinations by using the SCREEN options in the full screen SET command. Just enter SET at the dot prompt. 05/19/90 Q Q U E R Y (tm) Page 12 (c) 1989,1990 by Carlos Berguido - Vers 2.10D INFORMATION - CHANGING SCREEN COLORS (continued) - If you want to change any of the colors in QQUERY, you need to change the contents of QQUERY.QSM. At the dot prompt, enter: . RESTORE FROM QQUERY.QSM . DISPLAY MEMORY At this point you should see a list like this: QQSCRNNRML Pub C "W/N,N/W,N" QQSCRNBOLD Pub C "W+/N" QQSCRNBLNK Pub C "W+*/N,X" QQSCRNHLPB Pub C "N/W" QQSCRNHLPT Pub C "W/B,N/W" QQSCOLNRML Pub C "W/B,W/R,B" QQSCOLBOLD Pub C "W+/B" QQSCOLBLNK Pub C "W*/B,B/B" QQSCOLHLPB Pub C "N/W" QQSCOLHLPT Pub C "N/G,N/W" QQSCOPTION Pub C "/FLDPOP" 11 variables defined, 138 bytes used 245 variables available, 5862 bytes available Then, to change to: Normal text: blue on cyan, Enhanced: black on white, Border: cyan Enter: . QQSCOLNRML="B/BG,N/W,BG" Finally, save your changes to disk. . SAVE TO QQUERY.QSM By the way, if your new colors get way out of hand and you want to start over, just erase the QQUERY.QSM file from the disk. QQuery will create a new QQUERY.QSM with the default colors the next time you start QQuery. 05/19/90 Q Q U E R Y (tm) Page 13 (c) 1989,1990 by Carlos Berguido - Vers 2.10D INFORMATION - PROCEDURE FILES - QQuery is a PROCEDURE file consisting of 21 PRG files bound by FOXBIND and compiled encrypted by FOXPCOMP. QQuery is useful at the dot prompt. However, the intended use of QQuery is as a subroutine in the reporting sections of large database application procedure files. For example, in the middle of a reporting program, you will DO QQuery after choosing the report needed and before running it. You can do that with QQuery, even if the calling program is a procedure in an open procedure file. However, QQUERY NEEDS YOU TO SUPPLY IT WITH THE NAME OF THE PROCEDURE FILE THAT CALLS QQUERY. If you do not, QQuery will not re-open your procedure file when it is ready to return and your program will stop. So, before you call QQuery, create a memory variable QCALLER with the name of the procedure file that will be calling QQuery. Please note that the FoxBASE+ SYS(16) function returns the name of the current program or module, not necessarily the name of the procedure file containing the program or module. As an example, if you have a procedure file named MAIN.PRG that will be DOing QQuery, the following is recommended at the beginning of the procedure file MAIN.PRG: SET PROCEDURE TO MAIN QCALLER='MAIN' DO ...... && the name of your top procedure PROCEDURE ...... && the name of your first procedure For your information, the following are the first few lines of code in QQuery, at the beginning, before the first procedure: SET ECHO OFF RELEASE qqname,qqdesc,qquery PRIVATE ALL LIKE qq* PUBLIC qqname,qqdesc,qquery SET CONSOLE OFF qqtalk=SYS(2001,'TALK') && save environmental SETs SET TALK OFF SET CONSOLE ON qqesca=SYS(2001,'ESCAPE') && more SETs saved later SET ESCAPE OFF IF TYPE('qcaller')='U' && if undefined qcaller='' ENDIF SET PROCEDURE TO qquery DO qqstart && QQuery's top procedure SET PROCEDURE TO &qcaller RETURN && to calling procedure, PRG, or dot prompt 05/19/90 Q Q U E R Y (tm) Page 14 (c) 1989,1990 by Carlos Berguido - Vers 2.10D INFORMATION - READ ONLY ACCESS - For quality control reasons, you may want one user to create and modify all queries using QQuery and all other users to have "READ ONLY" access to the query files for generating reports. Source code for a program for query read only, QQREAD.PRG, is included on the QQuery distribution diskette, ready for you to customize. To enhance QQREAD.PRG, use your own error trapping routines to provide tests for the existence of file <alias>.QDB, index file <alias>.QDX, that there is at least 1 undeleted record in the file, and that there is at least one unused work area available. Have the <alias> user data file (not the query data file) open in the currently selected work area, and be sure that DELETED is SET ON. You may also wish to add Help screens. QQREAD.PRG is small enough to be bound with your other programs in your main procedure file. NOTES: 05/19/90 Q Q U E R Y (tm) Page 15 (c) 1989,1990 by Carlos Berguido - Vers 2.10D INFORMATION - NOTICE REGARDING QQUERY SOURCE CODE - QQuery is a copyrighted work by Carlos Berguido. When you register you are granted the right to modify the QQuery source code to optimize QQuery for your applications. As a registered user, you may choose to modify the source code to eliminate display on the screen of the copyright notice and/or the registration notice in applications you develop that use QQuery. You are granted that right as a registered user. However, you are NOT granted the right to delete either notice from the source code. You may write around the notices or comment them out so that they do not display but you may not erase either notice from the source code. Any copies of QQuery source code that you provide with your applications must contain the QQNOTICE.PRG module, and the copyright notice in the QQSTART.PRG module without any alterations to the content of any notice. Failure to provide these notices with the source code is a violation of the author's copyright. Thank-you for your cooperation. ANY USE OF QQUERY OTHER THAN FROM WITHIN THE APPLICATION PROGRAMS OF REGISTERED USERS REQUIRES REGISTRATION. 05/19/90 Q Q U E R Y (tm) Page 16 (c) 1989,1990 by Carlos Berguido - Vers 2.10D INFORMATION - INSTALLATION - These instructions assume that if you received QQuery in a one compressed "ZIP" file, that you have extracted the QQuery files onto a floppy diskette. Please choose one of these options: OPTION 1 - QQuery and your data files in the same directory: Insert the QQuery diskette in drive A. In this option, the QQuery program and all supporting files are installed in the same directory as your data files. If, for example, you keep your data in a subdirectory C:\FOX\MYDATA, get to DOS and enter: C: CD \FOX\MYDATA A:INSTALL The three QQuery system files QQUERY.*, the README file, and the six QQDEMO.* files will be copied into your data directory. When you are at the place to enter Fox commands working with your data files, you can start QQuery by entering either: DO QQUERY && QQuery directly DO QQDEMO && The demonstration OPTION 2 - Run QQuery from any directory by using PATH: If you have more than one data subdirectory, and you want to run QQuery with the data in any of them, you can repeat the installation described above for each directory. However, if you would like to save disk space and make it easier to upgrade QQuery, you should install QQuery in only one place. In this example, QQuery will be installed in a subdirectory below the standard Fox subdirectory (change \FOX to \FOXPRO below if that is where you keep FoxPro): C: MD \FOX\QQUERY CD \FOX\QQUERY A:INSTALL A subdirectory C:\FOX\QQUERY will be created on your hard disk and the QQuery files will be copied into it. Now, each time you start Fox, Fox needs to know where QQuery exists on your hard disk. Use MODIFY COMMAND or any text editor to create or modify the \FOX\CONFIG.FX (FoxPro uses CONFIG.FP) file and add the line: PATH = C:\FOX\QQUERY However, if there is already a PATH statement, just add ;C:\FOX\QQUERY to the end of the existing PATH statement. See "Fine Tuning" and the SET PATH TO command in the Fox User Guide for more information. After doing that, restart Fox. To use QQuery, enter either DO QQDEMO or DO QQUERY at the dot prompt or use DO QQUERY in your application programs.